using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using QLNhaSach.BUS.DTO;

namespace QLNhaSach.DAO
{
    class NhanVienKeToanDAO:NhanVienDAO
    {
        //Hien thi cong no tat ca khach hang
        public static DataTable CongNoKH()
        {
            return KhachHangDAO.DSKH();
        }

        //Hien thi hoa don tat ca khach hang
        public static DataTable XemDSHD()
        {
            return HoaDonDAO.DSHD();
        }

        //Xem mot hoa don cua mot khach hang
        public static DataTable XemMotHD(HoaDonDTO hd)
        {
            return HoaDonDAO.LayHDKH(hd);
        }

        //Xem chi tiet mot hoa don cua khach hang
        public static DataTable XemCTHD(HoaDonDTO hd)
        {
            return ChiTietHoaDonDAO.LayTatCaCTHD(hd);
        }

        //Xem tat ca hoa don cua mot khach hang
        public static DataTable XemTatCaHD(KhachHangDTO kh)
        {
            return HoaDonDAO.HDMotKH(kh);
        }

        //Xem cong no cua mot khach hang
        public static DataTable XemCongNoKH(KhachHangDTO kh)
        {
            return KhachHangDAO.XemCongNoKH(kh);
        }

        //Tim hoa don theo TenKH, MaKH, TenNV
        public static DataTable TimHoaDon(string sql)
        {
            return Config.AccessHelper.ExecuteQuery(sql);
        }
    }
}
